Finance methods
Create a finance method
- In the Navigation pane, highlight the Accounts Receivable > Setup > Finance Methods folder.
- Click . The New Finance Method window opens.
- Enter a unique Code for the finance method.
- Enter a Description of the finance method.
- In the Grace Period field, enter the number of days an invoice must be past due before finance charges are assessed. Leave this field blank or enter zero if finance charges should be assessed from the day the invoice is due.
- From the Aging Date Basis drop-down list, select the type of date to base aging on for the purpose of assessing finance charges. Your options are:
- Due Date. Use the due date calculated from the payment terms to determine aging dates.
- Invoice Date
- From the Basis Method drop-down list, select the method to use to calculate the balances on which finance charges are assessed. Your options are:
- Average Daily Balance. Calculate the balance at the end of each day of the assessment period (including the grace period) for all past due invoices which use this finance method. Divide the sum of these balances by the number of days in the assessment period.
Ending Balance. Calculate the balance at the end of the assessment period (including the grace period) for all past due invoices which use this finance method.
Note
The assessment period is determined when you run the Assess Finance Charges wizard.
- In the Minimum Basis field, enter the minimum past due balance on which to assess finance charges. If the calculated total balance of a customer's past due invoices which use this finance method is less than this amount, no finance charges are assessed.
-
To include outstanding credits that reference this finance method in balance calculations, mark the Include Credits checkbox.
Note
It's possible that some credits for this finance method should be included and others should be excluded from balance calculations. Since a credit must reference a finance method to be included in its calculations, you can remove or change the references to finance methods on the credits to exclude them.
-
To assess finance charges on outstanding finance charge invoices, mark the Compound Charges checkbox. Only finance charges that reference this finance method are included in calculations.
Important!
Laws may govern how finance charges, interest, and late fees are compounded. Check with the appropriate tax jurisdictions to verify that you are in compliance with all regulations.
- In the Assessment Rates section from the Rate Type drop-down list, select the type of rate to use to assess finance charges. Your options are:
Daily. The daily rate is multiplied times the number of days in the assessment period. If you select this option, the Daily Rate and Annual Rate fields are enabled. These fields work in conjunction with one another: If you enter a daily rate, ActivityHD calculates the annual rate and vice versa.
Note
The daily rate is the annual rate divided by 365 days per year. In the Assess Finance Charges wizard, the rate for the current assessment period is determined by multiplying the daily rate times the number of days in the period. This yields a more precise assessment rate than the fixed period rate when assessment period lengths are variable.
Example
If you enter an annual rate of 18.0000%, ActivityHD calculates a daily rate of 0.0493150684931507%. If you process finance charges for a 34-day assessment period, the rate would be:
34 * 0.0493150684931507% = 1.67671232876712%
- Period. The same assessment rate is applied every period. If you select this option, the Period Rate, Periods Per Year, and Annual Rate fields are enabled. First, enter the number of periods in a year. At this point, the Period Rate and Annual Rate fields work in conjunction with one another: If you enter a period rate, ActivityHD calculates the annual rate and vice versa.
- None. An assessment rate is not used; instead, a flat amount is charged each assessment period.
-
If you selected "Daily" or "Period" in the Rate Type field, the Minimum Charge field is available. Enter the minimum finance charge to assess. If the calculated charge, not including any flat amount, is less than the minimum, the minimum charge is assessed.
Example
Past Due Balance: $1,000.00
Period Rate: 1.500%
Minimum Charge: $20.00
Flat Amount: $10.00
Calculated Charge = $1,000.00 * 1.5% = $15.00
Adjusted Calculated Charge = $20.00 (since Minimum Charge is greater than Calculated Charge)
Total Finance Charge = $20.00 + 10.00 = $30.00 (Adjusted Calculated Charge + Flat Amount)
-
In the Flat Amount field, enter the flat amount to assess for finance charges or the flat amount to assess in addition to a calculated amount. If a flat amount does not apply, leave this field blank.
Note
You can specify both a flat amount and a rate on a finance method. This results in a finance charge assessment which is the total of the flat amount and the calculated amount based on the rate.
-
In the Invoice section in the Description field, enter the literal text and/or keywords to define the description to use on finance charge invoices.
Example
Suppose you want the description to contain the month and year that finance charges were assessed: "Finance Charges May 2014". To achieve this, you could enter the following:
Finance Charges <Period End Month Name> <Period End Year>
- In the Type field, select the default invoice type to use for finance charge invoices. The invoice type must have a classification of "Finance Charge". The Print Invoice flag and GL Batch field default based on the options from the selected invoice type. The invoice type also determines the invoice numbering scheme.
- In the Salesperson field, select the salesperson to assign by default to finance charge invoices. If finance charge invoices should not have a salesperson, leave this field blank.
- In the Terms field, select the default payment terms to assign on finance charge invoices. If finance charges are due on their invoice date and should not have payment terms, leave this field blank.
- In the ARCode field, select the default ARCode to assign on finance charge invoices. The Item Tax Category and Detail Description fields default from the selected ARCode. The sales account masks from the ARCode, class, customer, and attribute items determine the sales account on the finance charge invoice.
- The Item Tax Category field defaults from the ARCode you selected. If you need to change the default item tax category to assign on finance charge invoices, select the item tax category. The item tax category together with the customer tax category determine whether the finance charge invoice is taxable.
- The Detail Description field defaults from the ARCode you selected. If you need to change the default line item detail description for finance charge invoices, enter a new description. You can press F2 to open a popup where you can enter a lengthy description.
- If you want to print finance charge invoices, ensure the Print Invoice checkbox is marked. The state (marked or unmarked) of this checkbox defaults from the invoice type you selected.
- In the Attributes section, enter the attribute item values to apply for finance charge invoices.
- The AR account on a finance charge invoice can be built from the AR account masks on the invoice type, customer, customer class, and attribute items. If this is what you want to do, leave the AR Account field in the General Ledger section blank. If, instead, you want to specify a particular AR account for finance charge invoices which use this finance method, enter the account number in the field.
- The sales account on a finance charge invoice can be built from the sales account masks on the customer, customer class, ARCode, and attribute items. If this is what you want to do, leave the Sales Account field blank. If, instead, you want to specify a particular sales account for finance charge invoices which use this finance method, enter the account number in the field.
- From the GL Date Option drop-down list, select the date to use as the GL date for finance charge invoices. Your options are:
- Invoice Date
- Period End Date. Use the end date of the period that contains the invoice date (based on the calendar from the AR account on the invoice).
- The GL Batch field defaults from the invoice type you selected. If needed, you can enter a different name for the batch to process finance charge invoices with.
- Save the new finance method.
Finance Method Record ID
Finance Method tab
- Due Date. Use the due date calculated from the payment terms to determine aging dates.
- Invoice Date
- Average Daily Balance. Calculate the balance at the end of each day of the assessment period (including the grace period) for all past due invoices which use this finance method. Divide the sum of these balances by the number of days in the assessment period.
- Ending Balance. Calculate the balance at the end of the assessment period (including the grace period) for all past due invoices which use this finance method.
Note
The assessment period is determined when you run the Assess Finance Charges wizard.
If this checkbox is marked, outstanding credits that reference this finance method are included in balance calculations.
Note
It's possible that some credits for this finance method should be included and others should be excluded from balance calculations. Since a credit must reference a finance method to be included in its calculations, you can remove or change the references to finance methods on the credits to exclude them.
If this checkbox is marked, finance charges are assessed on outstanding finance charge invoices. Only finance charges that reference this finance method are included in calculations.
Important!
Laws may govern how finance charges, interest, and late fees are compounded. Check with the appropriate tax jurisdictions to verify that you are in compliance with all regulations.
The type of rate to use to assess finance charges. Your options are:
-
Daily. The daily rate is multiplied times the number of days in the assessment period. If you select this option, the Daily Rate and Annual Rate fields are enabled. These fields work in conjunction with one another: If you enter a daily rate, ActivityHD calculates the annual rate and vice versa.
Note
The daily rate is the annual rate divided by 365 days per year. In the Assess Finance Charges wizard, the rate for the current assessment period is determined by multiplying the daily rate times the number of days in the period. This yields a more precise assessment rate than the fixed period rate when assessment period lengths are variable.
Example
If you enter an annual rate of 18.0000%, ActivityHD calculates a daily rate of 0.0493150684931507%. If you process finance charges for a 34-day assessment period, the rate would be:
34 * 0.0493150684931507% = 1.67671232876712%
- Period. The same assessment rate is applied every period. If you select this option, the Period Rate, Periods Per Year, and Annual Rate fields are enabled. First, enter the number of periods in a year. At this point, the Period Rate and Annual Rate fields work in conjunction with one another: If you enter a period rate, ActivityHD calculates the annual rate and vice versa.
- None. An assessment rate is not used; instead, a flat amount is charged each assessment period.
If "Daily" is selected in the Rate Type field, this field is labeled "Daily Rate (%)". Enter the daily rate to assess for the finance method. ActivityHD calculates the annual rate for you and loads it in the Annual Rate field. Alternatively, if you leave this field blank and enter an annual rate, ActivityHD calculates the daily rate for you.
If "Period" is selected in the Rate Type field, this field is labeled "Period Rate (%)". Enter the period rate to assess for the finance method. Using the period rate and the number of periods per year, ActivityHD calculates the annual rate for you and loads it in the Annual Rate field. Alternatively, if you leave this field blank and enter the number of pay periods per year and an annual rate, ActivityHD calculates the period rate for you.
If "Daily" is selected in the Rate Type field, this field is labeled "Days Per Year". The value is set to "365" and the field is disabled.
If "Period" is selected in the Rate Type field, this field is labeled "Periods Per Year". Enter the number of assessment periods per year. For monthly assessments, enter "12".
If "Daily" is selected in the Rate Type field and a rate is entered in the Daily Rate field, this field displays the calculated annual rate for the finance method. Alternatively, if you leave the Daily Rate field blank and enter an annual rate here, ActivityHD calculates the daily rate for you.
If "Period" is selected in the Rate Type field and a rate is entered in the Period Rate field and the number of periods per year is specified, this field displays the calculated annual rate for the finance method. Alternatively, if you leave the Period Rate field blank, specify the number of periods per year, and enter an annual rate here, ActivityHD calculates the period rate for you.
This field is enabled if "Daily" or "Period" is selected in the Rate Type field. Enter the minimum finance charge to assess. If the calculated charge, not including any flat amount, is less than the minimum, the minimum charge is assessed.
Example
Past Due Balance: $1,000.00
Period Rate: 1.500%
Minimum Charge: $20.00
Flat Amount: $10.00
Calculated Charge = $1,000.00 * 1.5% = $15.00
Adjusted Calculated Charge = $20.00 (since Minimum Charge is greater than Calculated Charge)
Total Finance Charge = $20.00 + 10.00 = $30.00 (Adjusted Calculated Charge + Flat Amount)
The literal text and/or keywords that define the description to use on finance charge invoices for the finance method. If you enter literal text only, the same default description appears on all finance charge invoices for the finance method.
Example
Suppose you want the description to contain the month and year that finance charges were assessed: "Finance Charges May 2015". To achieve this, you could enter the following:
Finance Charges <Period End Month Name> <Period End Year>
The default invoice type to use for finance charge invoices with the finance method. The invoice type classification must be "Finance Charge" and an invoice scheme must be specified on the invoice type to determine invoice numbering. The Print Invoice flag and the GL Batch field default from the selected invoice type.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
The salesperson to assign by default to the finance charge invoices with the finance method. If finance charge invoices should not have a salesperson, leave this field blank.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
The default payment terms to assign on finance charge invoices for the finance method. If finance charges are due on the invoice date and should not have payment terms, leave this field blank.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
The default ARCode to assign on finance charge invoices. The Item Tax Category and Detail Description fields default from the ARCode. The sales account masks from the ARCode, class, customer, and attribute items determine the sales account on finance charge invoices.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
This field defaults to the item tax category on the selected ARCode. If you need to change the default item tax category to assign on finance charge invoices, select the appropriate item tax category. The item tax category together with the customer tax category determine whether the finance charge invoice is taxable.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
An attribute item that applies for finance charge invoices with the finance method. If the attribute is a required attribute, you must select an attribute item.
Attribute items provide additional ways to categorize invoices for reporting and they can contribute to the GL account masks used to derive the GL accounts used during invoice posting.
You can change an attribute item on a merged invoice; however, related changes to GL accounts only occur if the account was not manually entered and the associated GL entry is not merged.
Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
The AR account on a finance charge invoice can be derived from the AR account masks on the invoice type, customer, customer class, and attribute items. If this is what you want to do, leave this field blank. If instead, you want to specify a particular AR account for finance charges with the finance method, select the AR account number.
Press F2 to open the Account Expand dialog box where you can look up an account number, find an account number by its alias, build the account number by segment, or view setup and setup sources.
Press F3 to look up the account.
If an account is already selected, you can press F4 to open the record in the Account window.
The sales account on a finance charge invoice can be derived from the sales account masks on the customer, customer class, ARCode, and attribute items. If this is what you want to do, leave this field blank. If instead, you want to specify a particular sales account for finance charges with the finance method, select the sales account number.
Press F2 to open the Account Expand dialog box where you can look up an account number, find an account number by its alias, build the account number by segment, or view setup and setup sources.
Press F3 to look up the account.
If an account is already selected, you can press F4 to open the record in the Account window.
- Invoice Date
- Period End Date. Use the end date of the period that contains the invoice date (based on the calendar from the AR account on the invoice).
Custom tab
This tab is visible if custom fields exist for the entity. At a minimum, if there are custom fields, a Fields subtab will be present. One or more additional categories of subtabs may also be visible.
Fields subtab
This tab prompts for values for any custom fields set up for entity records of this entity type. Respond to the prompts as appropriate.
References subtab
This tab is visible if other records reference the current record.
Example
Suppose a custom field exists on PRCodes that references an ARCode. On the ARCode record, on the Custom > References subtab, you can view all the PRCodes which reference that ARCode.
Exchange Folder subtab
This tab is visible only if you set up a custom field with a data type of "Exchange Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified Exchange folder.
File subtab
This tab is visible only if you set up a custom field with a data type of "File". The label on the tab is the name assigned to the custom field.
This tab renders the contents of the specified file according to its file type.
Internet Address subtab
This tab is visible only if you set up a custom field with a data type of "Internet Address". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified web page.
Network Folder subtab
This tab is visible only if you set up a custom field with a data type of "Network Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified network folder.
Customers tab
The AR Customers pane shows the AR Customers HD view filtered to show all customers with the selected finance method.
Double-click a row in the pane to drill down to its record in the AR Customer window.
Attachments tab
The Attachments tab is visible if any record for a given entity has an attachment. If the Attachments tab is not visible, this implies that no record of the entity type has an attachment on it; however, once an attachment is added to any record of the entity type, the Attachments tab will become available.
Other tab
Finance methods security
Common accesses available on finance methods
Report Email dialog
- Windows user default account. Sends email using the user's Windows default email account. For most users, this is the account configured in Outlook or another email client application.
- Server personal. Sends email using the email configuration for the system or company server and the email address on the current user's authorized user record. The authorized user record must have a confirmed email address.
- Server generic. Sends email using the email configuration and "from" address for the system or company server. This option requires "Send generic" access to the Server Email resource.
AR invoice expression keywords
The following keywords are available in expressions for AR invoice descriptions:
Keyword | Value |
---|---|
<Period Begin Date> | Begin date in short date format |
<Period Begin Month> | Numeric value (1-12) for month of begin date |
<Period Begin Month Name> | Month name (January, February, ...) of begin date |
<Period Begin Day> | Numeric value (1-31) for day of begin date |
<Period Begin Year> | Four-digit numeric value for year of begin date |
<Period End Date> | End date in short date format |
<Period End Month> | Numeric value (1-12) for month of end date |
<Period End Month Name> | Month name (January, February, ...) of end date |
<Period End Day> | Numeric value (1-31) for day of end date |
<Period End Year> | Four-digit numeric value for year of end date |
<Merge #> | Merge number from the Post to AP process |
5225 S Loop 289, #207 Lubbock, TX 79424 806.687.8500 | 800.354.7152 |
© 2024 AccountingWare, LLC All rights reserved. |